﻿CREATE TABLE [dbo].[Agents]
(
	[ID] [int] NOT NULL IDENTITY(1, 1),
	[Name] [varchar] (50) NOT NULL,
	[Latitude] [varchar] (9) NULL,
	[Longitude] [varchar] (9) NULL,
	[MdNumber] [varchar] (4) NULL,
	[ActiveContacts] [float] NULL,
	ActiveAppointMade [float] NULL,
	ActiveAppointKept [float] NULL,
	ActivePresentation [float] NULL,
	ActiveAppointSale [float] NULL,
	LapsedContacts [float] NULL,
	LapsedAppointMade [float] NULL,
	LapsedAppointKept [float] NULL,
	LapsedPresentation [float] NULL,
	LapsedAppointSale [float] NULL,
	NeighborContacts [float] NULL,
	NeighborAppointMade [float] NULL,
	NeighborAppointKept [float] NULL,
	NeighborPresentation [float] NULL,
	NeighborAppointSale [float] NULL,
	BusinessContacts [float] NULL,
	BusinessAppointMade [float] NULL,
	BusinessAppointKept [float] NULL,
	BusinessPresentation [float] NULL,
	BusinessAppointSale [float] NULL,
	RefContacts [float] NULL,
	RefAppointMade [float] NULL,
	RefAppointKept [float] NULL,
	RefPresentation [float] NULL,
	RefAppointSale [float] NULL,
	TSystemContacts [float] NULL,
	TSystemAppointMade [float] NULL,
	TSystemAppointKept [float] NULL,
	TSystemPresentation [float] NULL,
	TSystemAppointSale [float] NULL,
	TargetMarketContacts [float] NULL,
	TargetMarketAppointMade [float] NULL,
	TargetMarketAppointKept [float] NULL,
	TargetMarketPresentation [float] NULL,
	TargetMarketAppointSale [float] NULL,
	FieldContacts [float] NULL,
	FieldAppointMade [float] NULL,
	FieldAppointKept [float] NULL,
	FieldPresentation [float] NULL,
	FieldAppointSale [float] NULL,
	AvgAPVperApp [float] NULL,
	AgentCode [varchar](50) NULL,
	Territory [varchar](2) NULL
);
